APPS.ASG_HELPER dependencies on FND_API

Line 557: FND_API.G_MISS_CHAR);

553: asg_config_pkg.load_row(p_param_name, p_param_value,
554: p_param_description,
555: sysdate, 1,
556: sysdate, 1,
557: FND_API.G_MISS_CHAR);
558: COMMIT;
559:
560: END set_config_param;
561:

Line 627: -- Returns FND_API.G_TRUE if the user synch is enabled

623: COMMIT;
624:
625: END disable_pub_synch;
626:
627: -- Returns FND_API.G_TRUE if the user synch is enabled
628: FUNCTION is_user_synch_enabled(p_user_name IN VARCHAR2,
629: p_disabled_synch_message OUT NOCOPY VARCHAR2)
630: return VARCHAR2 IS
631: l_synch_enabled VARCHAR2(1) := FND_API.G_TRUE;

Line 631: l_synch_enabled VARCHAR2(1) := FND_API.G_TRUE;

627: -- Returns FND_API.G_TRUE if the user synch is enabled
628: FUNCTION is_user_synch_enabled(p_user_name IN VARCHAR2,
629: p_disabled_synch_message OUT NOCOPY VARCHAR2)
630: return VARCHAR2 IS
631: l_synch_enabled VARCHAR2(1) := FND_API.G_TRUE;
632: l_disabled_user PLS_INTEGER;
633: l_disabled_pubs PLS_INTEGER;
634: l_query_string VARCHAR2(2000);
635: BEGIN

Line 644: l_synch_enabled := FND_API.G_FALSE;

640: WHERE user_name = p_user_name AND
641: enabled = 'N';
642:
643: IF l_disabled_user > 0 THEN
644: l_synch_enabled := FND_API.G_FALSE;
645: p_disabled_synch_message := asg_helper.get_param_value(
646: 'DISABLED_SYNCH_MESSAGE_UC');
647: return l_synch_enabled;
648: END IF;

Line 667: l_synch_enabled := FND_API.G_FALSE;

663: INTO l_disabled_pubs
664: USING p_user_name;
665:
666: IF (l_disabled_pubs >0) THEN
667: l_synch_enabled := FND_API.G_FALSE;
668: p_disabled_synch_message := asg_helper.get_param_value(
669: 'DISABLED_SYNCH_MESSAGE_ACC');
670: return l_synch_enabled;
671: END IF;

Line 692: l_synch_enabled := FND_API.G_FALSE;

688: INTO l_disabled_pubs
689: USING p_user_name;
690:
691: IF (l_disabled_pubs >0) THEN
692: l_synch_enabled := FND_API.G_FALSE;
693: p_disabled_synch_message := asg_helper.get_param_value(
694: 'DISABLED_SYNCH_MESSAGE_PATCH');
695: END IF;
696:

Line 729: IF ((p_pub_item = FND_API.G_MISS_CHAR) OR (p_pub_item IS NULL)) THEN

725: l_uname c_all_users%ROWTYPE;
726: l_recf1 c_new_users%ROWTYPE;
727: BEGIN
728:
729: IF ((p_pub_item = FND_API.G_MISS_CHAR) OR (p_pub_item IS NULL)) THEN
730: return;
731: END IF;
732:
733: l_pub_item := upper(p_pub_item);

Line 809: IF ((p_user_id = FND_API.G_MISS_NUM) OR (p_user_id IS NULL)) OR

805: WHERE user_id = p_user_id;
806: l_user_name VARCHAR2(100);
807: PRAGMA AUTONOMOUS_TRANSACTION;
808: BEGIN
809: IF ((p_user_id = FND_API.G_MISS_NUM) OR (p_user_id IS NULL)) OR
810: ((p_pub_name = FND_API.G_MISS_CHAR) OR (p_pub_name IS NULL)) THEN
811: return;
812: END IF;
813:

Line 810: ((p_pub_name = FND_API.G_MISS_CHAR) OR (p_pub_name IS NULL)) THEN

806: l_user_name VARCHAR2(100);
807: PRAGMA AUTONOMOUS_TRANSACTION;
808: BEGIN
809: IF ((p_user_id = FND_API.G_MISS_NUM) OR (p_user_id IS NULL)) OR
810: ((p_pub_name = FND_API.G_MISS_CHAR) OR (p_pub_name IS NULL)) THEN
811: return;
812: END IF;
813:
814: OPEN C_USER_NAME(p_user_id);

Line 839: IF ((p_user_id = FND_API.G_MISS_NUM) OR (p_user_id IS NULL)) OR

835: WHERE user_id = p_user_id;
836: l_user_name VARCHAR2(100);
837: PRAGMA AUTONOMOUS_TRANSACTION;
838: BEGIN
839: IF ((p_user_id = FND_API.G_MISS_NUM) OR (p_user_id IS NULL)) OR
840: ((p_pub_name = FND_API.G_MISS_CHAR) OR (p_pub_name IS NULL)) THEN
841: return;
842: END IF;
843:

Line 840: ((p_pub_name = FND_API.G_MISS_CHAR) OR (p_pub_name IS NULL)) THEN

836: l_user_name VARCHAR2(100);
837: PRAGMA AUTONOMOUS_TRANSACTION;
838: BEGIN
839: IF ((p_user_id = FND_API.G_MISS_NUM) OR (p_user_id IS NULL)) OR
840: ((p_pub_name = FND_API.G_MISS_CHAR) OR (p_pub_name IS NULL)) THEN
841: return;
842: END IF;
843:
844: OPEN C_USER_NAME(p_user_id);

Line 866: IF (p_group_name IS NULL) OR (p_group_name = FND_API.G_MISS_CHAR) THEN

862: l_grp_id NUMBER;
863: l_query_string VARCHAR2(2000);
864: BEGIN
865:
866: IF (p_group_name IS NULL) OR (p_group_name = FND_API.G_MISS_CHAR) THEN
867: return;
868: END IF;
869: l_grp_name := upper(p_group_name);
870: