302: CURSOR HIER_CSR IS
303: SELECT
304: PARTY_ID
305: FROM
306: OE_CREDIT_HIERARCHY_TEMP;
307: BEGIN
308: FND_PROFILE.GET(NAME => 'AR_CMGT_HIERARCHY_TYPE'
309: ,VAL => L_REL_TYPE);
310: SELECT
321: HZ_HIERARCHY_NODES B
322: WHERE B.HIERARCHY_TYPE = L_REL_TYPE
323: AND B.CHILD_ID = NVL(P_SPECIFIC_PARTY_ID
324: ,P_SPEC_PARTY_NUM_ID) );
325: INSERT INTO OE_CREDIT_HIERARCHY_TEMP
326: (PARTY_ID
327: ,PARTY_PARENT_ID
328: ,PARTY_NAME
329: ,PARTY_NUMBER
336: 0
337: FROM
338: HZ_PARTIES P
339: WHERE P.PARTY_ID = L_TOP_PARENT;
340: INSERT INTO OE_CREDIT_HIERARCHY_TEMP
341: (PARTY_ID
342: ,PARTY_PARENT_ID
343: ,PARTY_LEVEL)
344: SELECT
359: FROM
360: HZ_PARTIES
361: WHERE PARTY_ID = HIER_CSR_REC.PARTY_ID;
362: UPDATE
363: OE_CREDIT_HIERARCHY_TEMP
364: SET
365: PARTY_NAME = L_PARTY_NAME
366: ,PARTY_NUMBER = L_PARTY_NUMBER
367: WHERE PARTY_ID = HIER_CSR_REC.PARTY_ID;
622:
623: BEGIN
624: SELECT COUNT(1)
625: INTO L_COUNT
626: FROM OE_CREDIT_HIERARCHY_TEMP;
627:
628: /* IF L_COUNT=0
629: THEN
630: RETURN(L_COUNT);