DBA Data[Home] [Help]

APPS.OKL_AM_SERVICE_K_INT_WF dependencies on WF_ITEMS

Line 678: l_key WF_ITEMS.item_key%TYPE;

674: p_transaction_date IN DATE) IS
675:
676:
677: l_parameter_list WF_PARAMETER_LIST_T;
678: l_key WF_ITEMS.item_key%TYPE;
679: l_event_name WF_EVENTS.NAME%TYPE := 'oracle.apps.okl.am.servicekintegration';
680: l_seq NUMBER;
681:
682: -- Cursor to get the value of the sequence

Line 1123: l_item_type WF_ITEMS.item_type%TYPE;

1119: display_type IN VARCHAR2,
1120: document IN OUT NOCOPY VARCHAR2,
1121: document_type IN OUT NOCOPY VARCHAR2) IS
1122:
1123: l_item_type WF_ITEMS.item_type%TYPE;
1124: l_item_key WF_ITEMS.item_key%TYPE;
1125: l_colon NUMBER;
1126: l_msgbody VARCHAR2(32000);
1127: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1124: l_item_key WF_ITEMS.item_key%TYPE;

1120: document IN OUT NOCOPY VARCHAR2,
1121: document_type IN OUT NOCOPY VARCHAR2) IS
1122:
1123: l_item_type WF_ITEMS.item_type%TYPE;
1124: l_item_key WF_ITEMS.item_key%TYPE;
1125: l_colon NUMBER;
1126: l_msgbody VARCHAR2(32000);
1127: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1128: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1294: l_item_type WF_ITEMS.item_type%TYPE;

1290: display_type IN VARCHAR2,
1291: document IN OUT NOCOPY VARCHAR2,
1292: document_type IN OUT NOCOPY VARCHAR2) IS
1293:
1294: l_item_type WF_ITEMS.item_type%TYPE;
1295: l_item_key WF_ITEMS.item_key%TYPE;
1296: l_colon NUMBER;
1297: l_msgbody VARCHAR2(32000);
1298: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1295: l_item_key WF_ITEMS.item_key%TYPE;

1291: document IN OUT NOCOPY VARCHAR2,
1292: document_type IN OUT NOCOPY VARCHAR2) IS
1293:
1294: l_item_type WF_ITEMS.item_type%TYPE;
1295: l_item_key WF_ITEMS.item_key%TYPE;
1296: l_colon NUMBER;
1297: l_msgbody VARCHAR2(32000);
1298: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1299: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1444: l_item_type WF_ITEMS.item_type%TYPE;

1440: display_type IN VARCHAR2,
1441: document IN OUT NOCOPY VARCHAR2,
1442: document_type IN OUT NOCOPY VARCHAR2) IS
1443:
1444: l_item_type WF_ITEMS.item_type%TYPE;
1445: l_item_key WF_ITEMS.item_key%TYPE;
1446: l_colon NUMBER;
1447: l_msgbody VARCHAR2(32000);
1448: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1445: l_item_key WF_ITEMS.item_key%TYPE;

1441: document IN OUT NOCOPY VARCHAR2,
1442: document_type IN OUT NOCOPY VARCHAR2) IS
1443:
1444: l_item_type WF_ITEMS.item_type%TYPE;
1445: l_item_key WF_ITEMS.item_key%TYPE;
1446: l_colon NUMBER;
1447: l_msgbody VARCHAR2(32000);
1448: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1449: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1609: l_item_type WF_ITEMS.item_type%TYPE;

1605: display_type IN VARCHAR2,
1606: document IN OUT NOCOPY VARCHAR2,
1607: document_type IN OUT NOCOPY VARCHAR2) IS
1608:
1609: l_item_type WF_ITEMS.item_type%TYPE;
1610: l_item_key WF_ITEMS.item_key%TYPE;
1611: l_colon NUMBER;
1612: l_msgbody VARCHAR2(32000);
1613: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1610: l_item_key WF_ITEMS.item_key%TYPE;

1606: document IN OUT NOCOPY VARCHAR2,
1607: document_type IN OUT NOCOPY VARCHAR2) IS
1608:
1609: l_item_type WF_ITEMS.item_type%TYPE;
1610: l_item_key WF_ITEMS.item_key%TYPE;
1611: l_colon NUMBER;
1612: l_msgbody VARCHAR2(32000);
1613: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1614: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1748: l_item_type WF_ITEMS.item_type%TYPE;

1744: display_type IN VARCHAR2,
1745: document IN OUT NOCOPY VARCHAR2,
1746: document_type IN OUT NOCOPY VARCHAR2) IS
1747:
1748: l_item_type WF_ITEMS.item_type%TYPE;
1749: l_item_key WF_ITEMS.item_key%TYPE;
1750: l_colon NUMBER;
1751: l_msgbody VARCHAR2(32000);
1752: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1749: l_item_key WF_ITEMS.item_key%TYPE;

1745: document IN OUT NOCOPY VARCHAR2,
1746: document_type IN OUT NOCOPY VARCHAR2) IS
1747:
1748: l_item_type WF_ITEMS.item_type%TYPE;
1749: l_item_key WF_ITEMS.item_key%TYPE;
1750: l_colon NUMBER;
1751: l_msgbody VARCHAR2(32000);
1752: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1753: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;