DBA Data[Home] [Help]

APPS.QA_PARENT_CHILD_PKG dependencies on FND_GLOBAL

Line 965: X_Last_Updated_By => fnd_global.user_id,

961: X_Child_Collection_Id => p_collection_id,
962: X_Child_Occurrence => l_occurrence,
963: X_Enabled_Flag => 1,
964: X_Last_Update_Date => l_sysdate,
965: X_Last_Updated_By => fnd_global.user_id,
966: X_Creation_Date => l_sysdate,
967: X_Created_By => fnd_global.user_id,
968: X_Last_Update_Login => fnd_global.user_id,
969: X_Child_Txn_Header_Id => p_txn_header_id);

Line 967: X_Created_By => fnd_global.user_id,

963: X_Enabled_Flag => 1,
964: X_Last_Update_Date => l_sysdate,
965: X_Last_Updated_By => fnd_global.user_id,
966: X_Creation_Date => l_sysdate,
967: X_Created_By => fnd_global.user_id,
968: X_Last_Update_Login => fnd_global.user_id,
969: X_Child_Txn_Header_Id => p_txn_header_id);
970:
971: END IF;

Line 968: X_Last_Update_Login => fnd_global.user_id,

964: X_Last_Update_Date => l_sysdate,
965: X_Last_Updated_By => fnd_global.user_id,
966: X_Creation_Date => l_sysdate,
967: X_Created_By => fnd_global.user_id,
968: X_Last_Update_Login => fnd_global.user_id,
969: X_Child_Txn_Header_Id => p_txn_header_id);
970:
971: END IF;
972: l_count := l_count + 1;

Line 1493: l_user_id := fnd_global.user_id;

1489:
1490: RETURN;
1491: END IF;
1492:
1493: l_user_id := fnd_global.user_id;
1494: l_login_id := fnd_global.login_id;
1495: l_date := sysdate;
1496:
1497: -- Gapless Sequence Proj. rponnusa Wed Jul 30 04:52:45 PDT 2003

Line 1494: l_login_id := fnd_global.login_id;

1490: RETURN;
1491: END IF;
1492:
1493: l_user_id := fnd_global.user_id;
1494: l_login_id := fnd_global.login_id;
1495: l_date := sysdate;
1496:
1497: -- Gapless Sequence Proj. rponnusa Wed Jul 30 04:52:45 PDT 2003
1498: -- Findout txn header ID for the child record

Line 4174: FND_GLOBAL.USER_ID,

4170: QR.COLLECTION_ID,
4171: QR.OCCURRENCE,
4172: 2,
4173: SYSDATE,
4174: FND_GLOBAL.USER_ID,
4175: SYSDATE,
4176: FND_GLOBAL.USER_ID,
4177: FND_GLOBAL.USER_ID,
4178: QR.TXN_HEADER_ID

Line 4176: FND_GLOBAL.USER_ID,

4172: 2,
4173: SYSDATE,
4174: FND_GLOBAL.USER_ID,
4175: SYSDATE,
4176: FND_GLOBAL.USER_ID,
4177: FND_GLOBAL.USER_ID,
4178: QR.TXN_HEADER_ID
4179: FROM QA_RESULTS QR
4180: WHERE QR.PLAN_ID = p_child_plan_id

Line 4177: FND_GLOBAL.USER_ID,

4173: SYSDATE,
4174: FND_GLOBAL.USER_ID,
4175: SYSDATE,
4176: FND_GLOBAL.USER_ID,
4177: FND_GLOBAL.USER_ID,
4178: QR.TXN_HEADER_ID
4179: FROM QA_RESULTS QR
4180: WHERE QR.PLAN_ID = p_child_plan_id
4181: AND QR.COLLECTION_ID = p_child_collection_id

Line 4380: FND_GLOBAL.USER_ID,

4376: p_collection_id,
4377: QA_OCCURRENCE_S.NEXTVAL,
4378: 2,
4379: SYSDATE,
4380: FND_GLOBAL.USER_ID,
4381: SYSDATE,
4382: FND_GLOBAL.USER_ID,
4383: FND_GLOBAL.USER_ID,
4384: p_txn_header_id

Line 4382: FND_GLOBAL.USER_ID,

4378: 2,
4379: SYSDATE,
4380: FND_GLOBAL.USER_ID,
4381: SYSDATE,
4382: FND_GLOBAL.USER_ID,
4383: FND_GLOBAL.USER_ID,
4384: p_txn_header_id
4385: FROM QA_RESULTS QR
4386: WHERE QR.PLAN_ID = p_plan_id

Line 4383: FND_GLOBAL.USER_ID,

4379: SYSDATE,
4380: FND_GLOBAL.USER_ID,
4381: SYSDATE,
4382: FND_GLOBAL.USER_ID,
4383: FND_GLOBAL.USER_ID,
4384: p_txn_header_id
4385: FROM QA_RESULTS QR
4386: WHERE QR.PLAN_ID = p_plan_id
4387: AND QR.COLLECTION_ID = p_collection_id

Line 4420: ' fnd_global.user_id, ' ||

4416: ' SELECT QPRR.CHILD_COLLECTION_ID, ' ||
4417: ' QPRR.CHILD_OCCURRENCE, ' ||
4418: ' sysdate, ' ||
4419: ' sysdate, ' ||
4420: ' fnd_global.user_id, ' ||
4421: ' fnd_global.user_id, ' ||
4422: ' sysdate, ' ||
4423: ' sysdate, ' ||
4424: ' fnd_global.user_id, ' ||

Line 4421: ' fnd_global.user_id, ' ||

4417: ' QPRR.CHILD_OCCURRENCE, ' ||
4418: ' sysdate, ' ||
4419: ' sysdate, ' ||
4420: ' fnd_global.user_id, ' ||
4421: ' fnd_global.user_id, ' ||
4422: ' sysdate, ' ||
4423: ' sysdate, ' ||
4424: ' fnd_global.user_id, ' ||
4425: ' fnd_global.user_id, ' ||

Line 4424: ' fnd_global.user_id, ' ||

4420: ' fnd_global.user_id, ' ||
4421: ' fnd_global.user_id, ' ||
4422: ' sysdate, ' ||
4423: ' sysdate, ' ||
4424: ' fnd_global.user_id, ' ||
4425: ' fnd_global.user_id, ' ||
4426: ' fnd_global.user_id, ' ||
4427: ' 2, ' ||
4428: ' -1, ' ||

Line 4425: ' fnd_global.user_id, ' ||

4421: ' fnd_global.user_id, ' ||
4422: ' sysdate, ' ||
4423: ' sysdate, ' ||
4424: ' fnd_global.user_id, ' ||
4425: ' fnd_global.user_id, ' ||
4426: ' fnd_global.user_id, ' ||
4427: ' 2, ' ||
4428: ' -1, ' ||
4429: ' QR.ORGANIZATION_ID, ' ||

Line 4426: ' fnd_global.user_id, ' ||

4422: ' sysdate, ' ||
4423: ' sysdate, ' ||
4424: ' fnd_global.user_id, ' ||
4425: ' fnd_global.user_id, ' ||
4426: ' fnd_global.user_id, ' ||
4427: ' 2, ' ||
4428: ' -1, ' ||
4429: ' QR.ORGANIZATION_ID, ' ||
4430: ' QPRR.CHILD_PLAN_ID, ' ||