DBA Data[Home] [Help]

APPS.AHL_FMP_MR_REVISION_PVT dependencies on FND_GLOBAL

Line 709: X_CREATED_BY =>fnd_global.user_id,

705: -- defaulting to Yes for these attributes when new revision is created
706: X_COPY_INIT_ACCOMPL_FLAG =>'Y',
707: X_COPY_DEFERRALS_FLAG =>'Y',
708: X_CREATION_DATE =>sysdate,
709: X_CREATED_BY =>fnd_global.user_id,
710: X_LAST_UPDATE_DATE =>sysdate,
711: X_LAST_UPDATED_BY =>fnd_global.user_id,
712: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
713: end loop;

Line 711: X_LAST_UPDATED_BY =>fnd_global.user_id,

707: X_COPY_DEFERRALS_FLAG =>'Y',
708: X_CREATION_DATE =>sysdate,
709: X_CREATED_BY =>fnd_global.user_id,
710: X_LAST_UPDATE_DATE =>sysdate,
711: X_LAST_UPDATED_BY =>fnd_global.user_id,
712: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
713: end loop;
714:
715:

Line 712: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);

708: X_CREATION_DATE =>sysdate,
709: X_CREATED_BY =>fnd_global.user_id,
710: X_LAST_UPDATE_DATE =>sysdate,
711: X_LAST_UPDATED_BY =>fnd_global.user_id,
712: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
713: end loop;
714:
715:
716: for l_association_rec in CurGetDocTitledet

Line 757: X_CREATED_BY =>fnd_global.user_id,

753: X_FIGURE =>l_association_rec.figure,
754: X_PAGE =>l_association_rec.page,
755: X_NOTE =>l_association_rec.note,
756: X_CREATION_DATE =>sysdate,
757: X_CREATED_BY =>fnd_global.user_id,
758: X_LAST_UPDATE_DATE =>sysdate,
759: X_LAST_UPDATED_BY =>fnd_global.user_id,
760: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
761:

Line 759: X_LAST_UPDATED_BY =>fnd_global.user_id,

755: X_NOTE =>l_association_rec.note,
756: X_CREATION_DATE =>sysdate,
757: X_CREATED_BY =>fnd_global.user_id,
758: X_LAST_UPDATE_DATE =>sysdate,
759: X_LAST_UPDATED_BY =>fnd_global.user_id,
760: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
761:
762: end loop;
763:

Line 760: X_LAST_UPDATE_LOGIN => fnd_global.login_id);

756: X_CREATION_DATE =>sysdate,
757: X_CREATED_BY =>fnd_global.user_id,
758: X_LAST_UPDATE_DATE =>sysdate,
759: X_LAST_UPDATED_BY =>fnd_global.user_id,
760: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
761:
762: end loop;
763:
764: for l_mr_route_rec in CurGetRoutedet

Line 793: X_CREATED_BY =>fnd_global.user_id,

789: X_ATTRIBUTE13 =>l_mr_route_Rec.ATTRIBUTE14,
790: X_ATTRIBUTE14 =>l_mr_route_Rec.ATTRIBUTE15,
791: X_ATTRIBUTE15 =>l_mr_route_Rec.ATTRIBUTE15,
792: X_CREATION_DATE =>sysdate,
793: X_CREATED_BY =>fnd_global.user_id,
794: X_LAST_UPDATE_DATE =>sysdate,
795: X_LAST_UPDATED_BY =>fnd_global.user_id,
796: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
797: L_MR_ROUTE_INDEX:=L_MR_ROUTE_INDEX+1;

Line 795: X_LAST_UPDATED_BY =>fnd_global.user_id,

791: X_ATTRIBUTE15 =>l_mr_route_Rec.ATTRIBUTE15,
792: X_CREATION_DATE =>sysdate,
793: X_CREATED_BY =>fnd_global.user_id,
794: X_LAST_UPDATE_DATE =>sysdate,
795: X_LAST_UPDATED_BY =>fnd_global.user_id,
796: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
797: L_MR_ROUTE_INDEX:=L_MR_ROUTE_INDEX+1;
798: l_temp_mr_route_tbl(L_MR_ROUTE_INDEX).OLD_MR_ROUTE_ID:=l_old_mr_route_id;
799: l_temp_mr_route_tbl(L_MR_ROUTE_INDEX).NEW_MR_ROUTE_ID:=l_new_mr_ROUTE_ID;

Line 796: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);

792: X_CREATION_DATE =>sysdate,
793: X_CREATED_BY =>fnd_global.user_id,
794: X_LAST_UPDATE_DATE =>sysdate,
795: X_LAST_UPDATED_BY =>fnd_global.user_id,
796: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
797: L_MR_ROUTE_INDEX:=L_MR_ROUTE_INDEX+1;
798: l_temp_mr_route_tbl(L_MR_ROUTE_INDEX).OLD_MR_ROUTE_ID:=l_old_mr_route_id;
799: l_temp_mr_route_tbl(L_MR_ROUTE_INDEX).NEW_MR_ROUTE_ID:=l_new_mr_ROUTE_ID;
800: End loop;

Line 849: X_CREATED_BY =>fnd_global.user_id,

845: X_ATTRIBUTE13 =>l_mr_route_seq_rec.ATTRIBUTE13,
846: X_ATTRIBUTE14 =>l_mr_route_seq_rec.ATTRIBUTE14,
847: X_ATTRIBUTE15 =>l_mr_route_seq_rec.ATTRIBUTE15,
848: X_CREATION_DATE =>sysdate,
849: X_CREATED_BY =>fnd_global.user_id,
850: X_LAST_UPDATE_DATE =>sysdate,
851: X_LAST_UPDATED_BY =>fnd_global.user_id,
852: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
853: end loop;

Line 851: X_LAST_UPDATED_BY =>fnd_global.user_id,

847: X_ATTRIBUTE15 =>l_mr_route_seq_rec.ATTRIBUTE15,
848: X_CREATION_DATE =>sysdate,
849: X_CREATED_BY =>fnd_global.user_id,
850: X_LAST_UPDATE_DATE =>sysdate,
851: X_LAST_UPDATED_BY =>fnd_global.user_id,
852: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
853: end loop;
854: CLOSE CurGetRouteSeqDet;
855:

Line 852: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);

848: X_CREATION_DATE =>sysdate,
849: X_CREATED_BY =>fnd_global.user_id,
850: X_LAST_UPDATE_DATE =>sysdate,
851: X_LAST_UPDATED_BY =>fnd_global.user_id,
852: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
853: end loop;
854: CLOSE CurGetRouteSeqDet;
855:
856: END LOOP;

Line 900: fnd_global.user_id,

896: (
897: AHL_MR_EFFECTIVITIES_S.NEXTVAL,
898: 1,
899: SYSDATE,
900: fnd_global.user_id,
901: SYSDATE,
902: fnd_global.user_id,
903: fnd_global.user_id,
904: x_new_mr_header_id,

Line 902: fnd_global.user_id,

898: 1,
899: SYSDATE,
900: fnd_global.user_id,
901: SYSDATE,
902: fnd_global.user_id,
903: fnd_global.user_id,
904: x_new_mr_header_id,
905: l_mr_eff_rec.NAME,
906: l_mr_eff_rec.THRESHOLD_DATE,

Line 903: fnd_global.user_id,

899: SYSDATE,
900: fnd_global.user_id,
901: SYSDATE,
902: fnd_global.user_id,
903: fnd_global.user_id,
904: x_new_mr_header_id,
905: l_mr_eff_rec.NAME,
906: l_mr_eff_rec.THRESHOLD_DATE,
907: l_mr_eff_rec.INVENTORY_ITEM_ID,

Line 981: fnd_global.user_id,

977: (
978: AHL_MR_INTERVALS_S.NEXTVAL,
979: l_interval_rec.OBJECT_VERSION_NUMBER,
980: sysdate,
981: fnd_global.user_id,
982: sysdate,
983: fnd_global.user_id,
984: fnd_global.user_id,
985: l_new_mr_effectivity_id,

Line 983: fnd_global.user_id,

979: l_interval_rec.OBJECT_VERSION_NUMBER,
980: sysdate,
981: fnd_global.user_id,
982: sysdate,
983: fnd_global.user_id,
984: fnd_global.user_id,
985: l_new_mr_effectivity_id,
986: l_interval_rec.COUNTER_ID,
987: l_interval_rec.INTERVAL_VALUE,

Line 984: fnd_global.user_id,

980: sysdate,
981: fnd_global.user_id,
982: sysdate,
983: fnd_global.user_id,
984: fnd_global.user_id,
985: l_new_mr_effectivity_id,
986: l_interval_rec.COUNTER_ID,
987: l_interval_rec.INTERVAL_VALUE,
988: l_interval_rec.EARLIEST_DUE_VALUE,

Line 1075: fnd_global.user_id,

1071: l_mr_effect_dtls_rec.MANUFACTURE_DATE_FROM,
1072: l_mr_effect_dtls_rec.MANUFACTURE_DATE_TO,
1073: 1,
1074: SYSDATE,
1075: fnd_global.user_id,
1076: SYSDATE,
1077: fnd_global.user_id,
1078: fnd_global.user_id,
1079: l_mr_effect_dtls_rec.ATTRIBUTE_CATEGORY,

Line 1077: fnd_global.user_id,

1073: 1,
1074: SYSDATE,
1075: fnd_global.user_id,
1076: SYSDATE,
1077: fnd_global.user_id,
1078: fnd_global.user_id,
1079: l_mr_effect_dtls_rec.ATTRIBUTE_CATEGORY,
1080: l_mr_effect_dtls_rec.ATTRIBUTE1,
1081: l_mr_effect_dtls_rec.ATTRIBUTE2,

Line 1078: fnd_global.user_id,

1074: SYSDATE,
1075: fnd_global.user_id,
1076: SYSDATE,
1077: fnd_global.user_id,
1078: fnd_global.user_id,
1079: l_mr_effect_dtls_rec.ATTRIBUTE_CATEGORY,
1080: l_mr_effect_dtls_rec.ATTRIBUTE1,
1081: l_mr_effect_dtls_rec.ATTRIBUTE2,
1082: l_mr_effect_dtls_rec.ATTRIBUTE3,

Line 1148: fnd_global.user_id,

1144: values(
1145: AHL_MR_RELATIONSHIPS_S.NEXTVAL,
1146: 1,
1147: SYSDATE,
1148: fnd_global.user_id,
1149: SYSDATE,
1150: fnd_global.user_id,
1151: fnd_global.user_id,
1152: l_rel_Rec.MR_HEADER_ID,

Line 1150: fnd_global.user_id,

1146: 1,
1147: SYSDATE,
1148: fnd_global.user_id,
1149: SYSDATE,
1150: fnd_global.user_id,
1151: fnd_global.user_id,
1152: l_rel_Rec.MR_HEADER_ID,
1153: l_rel_Rec.RELATED_MR_HEADER_ID,
1154: l_mr_relation_Rec.RELATIONSHIP_CODE,

Line 1151: fnd_global.user_id,

1147: SYSDATE,
1148: fnd_global.user_id,
1149: SYSDATE,
1150: fnd_global.user_id,
1151: fnd_global.user_id,
1152: l_rel_Rec.MR_HEADER_ID,
1153: l_rel_Rec.RELATED_MR_HEADER_ID,
1154: l_mr_relation_Rec.RELATIONSHIP_CODE,
1155: l_mr_relation_Rec.ATTRIBUTE_CATEGORY,

Line 1210: fnd_global.user_id,

1206: (
1207: AHL_MR_VISIT_TYPES_S.NEXTVAL,
1208: 1,
1209: SYSDATE,
1210: fnd_global.user_id,
1211: SYSDATE,
1212: fnd_global.user_id,
1213: fnd_global.user_id,
1214: x_new_MR_HEADER_ID,

Line 1212: fnd_global.user_id,

1208: 1,
1209: SYSDATE,
1210: fnd_global.user_id,
1211: SYSDATE,
1212: fnd_global.user_id,
1213: fnd_global.user_id,
1214: x_new_MR_HEADER_ID,
1215: l_mrvisttype_rec.SECURITY_GROUP_ID,
1216: l_mrvisttype_rec.ATTRIBUTE_CATEGORY,

Line 1213: fnd_global.user_id,

1209: SYSDATE,
1210: fnd_global.user_id,
1211: SYSDATE,
1212: fnd_global.user_id,
1213: fnd_global.user_id,
1214: x_new_MR_HEADER_ID,
1215: l_mrvisttype_rec.SECURITY_GROUP_ID,
1216: l_mrvisttype_rec.ATTRIBUTE_CATEGORY,
1217: l_mrvisttype_rec.ATTRIBUTE1,

Line 1643: P_REQUESTER_USERID =>fnd_global.user_id,

1639: P_ORIG_STATUS_CODE =>'ACTIVE',
1640: -- P_NEW_STATUS_CODE =>'APPROVED',
1641: P_NEW_STATUS_CODE => l_approved_status_code,
1642: P_REJECT_STATUS_CODE =>'REJECTED',
1643: P_REQUESTER_USERID =>fnd_global.user_id,
1644: P_NOTES_FROM_REQUESTER =>'',
1645: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
1646: P_ITEM_TYPE =>'AHLGAPP',
1647: p_application_usg_code =>G_APPLN_USAGE