DBA Data[Home] [Help]

APPS.PQH_RBC_LOAD_OBJECTS dependencies on FND_GLOBAL

Line 95: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;

91: l_last_update_date := sysdate;
92: l_last_update_login := 0;
93: l_effective_date := nvl(to_date(p_effective_start_date,'DD/MM/YYYY'),sysdate);
94: --
95: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
96: --
97: Open csr_pl;
98: Fetch csr_pl into l_pl_id,l_ovn;
99: Close csr_pl;

Line 249: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;

245: l_last_update_date := sysdate;
246: l_last_update_login := 0;
247: l_effective_date := nvl(to_date(p_effective_date,'DD/MM/YYYY'),sysdate);
248: --
249: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
250: --
251: /*
252: Open csr_pl;
253: Fetch csr_pl into l_pl_id;

Line 413: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;

409: l_last_update_date := sysdate;
410: l_last_update_login := 0;
411: l_effective_date := nvl(to_date(p_effective_date,'DD/MM/YYYY'),sysdate);
412: --
413: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
414: --
415: --
416: Open csr_rmn(p_node_short_code);
417: Fetch csr_rmn into l_rate_matrix_node_id;

Line 609: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;

605: l_last_update_date := sysdate;
606: l_last_update_login := 0;
607: l_effective_date := nvl(to_date(p_effective_start_date,'DD/MM/YYYY'),sysdate);
608: --
609: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
610: --
611: Open csr_plan;
612: Fetch csr_plan into l_rate_matrix_node_id, l_pl_id;
613: Close csr_plan;

Line 853: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;

849: l_creation_date := sysdate;
850: l_last_update_date := sysdate;
851: l_last_update_login := 0;
852: --
853: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
854: --
855: open c1;
856: fetch c1 into l_language ;
857: close c1;

Line 1112: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;

1108:
1109: -- l_effective_date := SYSDATE;
1110: l_effective_date := nvl(to_date(p_effective_start_date,'DD/MM/YYYY'),sysdate);
1111: -- TEST
1112: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
1113: --
1114: Open csr_crd;
1115: Fetch csr_crd into l_criteria_rate_defn_id;
1116: Close csr_crd;

Line 1290: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;

1286: l_last_update_date := sysdate;
1287: l_last_update_login := 0;
1288: --
1289: l_effective_date := nvl(to_date(p_effective_start_date,'DD/MM/YYYY'),sysdate);
1290: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
1291: --
1292: Open csr_crd;
1293: Fetch csr_crd into l_criteria_rate_defn_id;
1294: Close csr_crd;

Line 1455: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;

1451: l_creation_date := sysdate;
1452: l_last_update_date := sysdate;
1453: l_last_update_login := 0;
1454: --
1455: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
1456: --
1457: -- l_effective_date := SYSDATE;
1458: l_effective_date := nvl(to_date(p_effective_start_date,'DD/MM/YYYY'),sysdate);
1459: -- TEST

Line 1629: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;

1625: l_creation_date := sysdate;
1626: l_last_update_date := sysdate;
1627: l_last_update_login := 0;
1628: --
1629: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
1630: --
1631: l_effective_date := nvl(to_date(p_effective_start_date,'DD/MM/YYYY'),sysdate);
1632: -- TEST
1633: -- l_effective_date := sysdate;